﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Other.aspx.cs" Inherits="Other_Other" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style2
        {
            font-size: medium;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <strong><span class="style2">其他部分</span></strong><br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AutoGenerateColumns="False" DataKeyNames="JH,SBRQ" 
        DataSourceID="SqlDataSource1" onrowupdating="GridView1_RowUpdating">
        <Columns>
            <asp:CommandField ShowEditButton="True" EditText="录入" />
            <asp:BoundField DataField="JH" HeaderText="井号" ReadOnly="True" 
                SortExpression="JH" />
            <asp:BoundField DataField="DH" HeaderText="队号" SortExpression="DH" />
            <asp:BoundField DataField="SBRQ" DataFormatString="{0:d}" HeaderText="上报日期" 
                ReadOnly="True" SortExpression="SBRQ" />
            <asp:BoundField DataField="KGRQ" DataFormatString="{0:d}" HeaderText="开工日期" 
                SortExpression="KGRQ" />
            <asp:BoundField DataField="WGRQ" DataFormatString="{0:d}" HeaderText="完工日期" 
                SortExpression="WGRQ" />
            <asp:BoundField DataField="SGFS" HeaderText="施工方式" SortExpression="SGFS" />
            <asp:BoundField DataField="CSCD" HeaderText="措施层段" SortExpression="CSCD" />
            <asp:BoundField DataField="CWSYHD" HeaderText="层位砂岩厚度" 
                SortExpression="CWSYHD" />
            <asp:BoundField DataField="CWYXHD" HeaderText="层位有效厚度" 
                SortExpression="CWYXHD" />
            <asp:BoundField DataField="SGJDDS1" HeaderText="施工井段顶深" 
                SortExpression="SGJDDS1" />
            <asp:BoundField DataField="SGJDDS2" HeaderText="施工井段底深" 
                SortExpression="SGJDDS2" />
            <asp:BoundField DataField="BZ" HeaderText="备注" SortExpression="BZ" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
        DeleteCommand="DELETE FROM &quot;BC_QITA&quot; WHERE &quot;JH&quot; = :JH AND &quot;SBRQ&quot; = :SBRQ" 
        InsertCommand="INSERT INTO &quot;BC_QITA&quot; (&quot;JH&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;SGFS&quot;, &quot;BZ&quot;, &quot;SBRQ&quot;, &quot;DH&quot;) VALUES (:JH, :KGRQ, :WGRQ, :SGFS, :BZ, :SBRQ, :DH)" 
        ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
        SelectCommand="SELECT JH, KGRQ, WGRQ, SGFS, BZ, SBRQ, DH, CWSYHD, CWYXHD, SGJDDS1, SGJDDS2, CSCD FROM BC_QITA WHERE (KGRQ IS NULL) OR (WGRQ IS NULL) OR (SGFS IS NULL) OR (CWSYHD IS NULL) OR (CWYXHD IS NULL) OR (SGJDDS1 IS NULL) OR (SGJDDS2 IS NULL) OR (CSCD IS NULL) ORDER BY SBRQ" 
        
        
        UpdateCommand="UPDATE &quot;BC_QITA&quot; SET &quot;KGRQ&quot; = :KGRQ, &quot;WGRQ&quot; = :WGRQ, &quot;SGFS&quot; = :SGFS, &quot;BZ&quot; = :BZ, &quot;DH&quot; = :DH ,&quot;CWSYHD&quot;=:CWSYHD,&quot;CWYXHD&quot;=:CWYXHD,&quot;SGJDDS1&quot;= :SGJDDS1,&quot;SGJDDS2&quot;=:SGJDDS2 ,&quot;CSCD&quot; = :CSCD WHERE &quot;JH&quot; = :JH AND &quot;SBRQ&quot; = :SBRQ">
        <DeleteParameters>
            <asp:Parameter Name="JH" Type="String" />
            <asp:Parameter Name="SBRQ" Type="DateTime" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="JH" Type="String" />
            <asp:Parameter Name="KGRQ" Type="DateTime" />
            <asp:Parameter Name="WGRQ" Type="DateTime" />
            <asp:Parameter Name="SGFS" Type="String" />
            <asp:Parameter Name="BZ" Type="String" />
            <asp:Parameter Name="SBRQ" Type="DateTime" />
            <asp:Parameter Name="DH" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="KGRQ" Type="DateTime" />
            <asp:Parameter Name="WGRQ" Type="DateTime" />
            <asp:Parameter Name="SGFS" Type="String" />
            <asp:Parameter Name="BZ" Type="String" />
            <asp:Parameter Name="DH" Type="String" />
            <asp:Parameter Name="CWSYHD" />
            <asp:Parameter Name="CWYXHD" />
            <asp:Parameter Name="SGJDDS1" />
            <asp:Parameter Name="SGJDDS2" />
            <asp:Parameter Name="CSCD" />
            <asp:Parameter Name="JH" Type="String" />
            <asp:Parameter Name="SBRQ" Type="DateTime" />
        </UpdateParameters>
    </asp:SqlDataSource>
</asp:Content>

